Using DataDirect Spy^™ with JDBC Data Sources

The JDBC driver implements the following features defined by the JDBC 2.0 Optional Package:

JNDI for Naming Databases
Connection Pooling
Distributed Transaction Management (DTC)

You can use Spy to track JDBC calls with all of these features. The com.ddtek.jdbcx.sequelink.SequeLinkDataSource class supports the SpyAttributes connection attribute, which specifies a semi-colon-separated list of Spy attributes as described in "DataDirect Spy™ Attributes". See "JDBC Connection URL Examples:" for more information about configuring JDBC data sources.

The following examples create a SequeLinkDataSource and specifies that all JDBC calls must be logged in the file /tmp/spy.log, including the name of the current thread:

... 
SequeLinkDataSource sds=new SequeLinkDataSource(): 
sds.setServerName("MyServer"); 
sds.setPortNumber(1234); 
sds.setSpyAttributes("log=(file)/tmp/spy.log;logTName=yes"); 
Connection conn=sds.getConnection("scott","tiger"); 
...